SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 64553: A transformation in SAS® Data Integration Studio causes warning messages when an external file is the source or target

DetailsAboutRate It

You might receive a warning message when you execute a SAS Data Integration Studio job that contains a User Written Code, File Reader, File Writer, Hadoop File Reader, or Hadoop File Writer transformation. The warning message can be similar to the following:

WARNING: Apparent symbolic reference macro-variable-name not resolved.

The reason the warning appears is because of a feature that was added to SAS Data Integration Studio in SAS® 9.4 (TS1M3). When the source or target of a transformation is an external file, the file name is added to the macro variables _INPUT or _OUTPUT.  You receive the warning when the file name contains a macro variable, which is initialized in the body of any user-written code for the transformation.  The warning is issued when the macro variable in the file name of the _INPUT or _OUTPUT value is executed prior to the initialization of the macro.

Beginning with SAS® 9.4 (TS1M6), a new option, Generate macro variables for external files, is available for the transformations in order to allow external files as source and targets. You should change the option setting to No to avoid the warning. The No setting indicates that the macro variable definitions for _INPUT and _OUTPUT should not be generated. The default setting for the option is Yes



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Data Integration StudioWindows 7 Home Premium x644.9014.9049.4 TS1M39.4 TS1M6
Windows 7 Home Premium 32 bit4.9014.9049.4 TS1M39.4 TS1M6
Windows 7 Enterprise x644.9014.9049.4 TS1M39.4 TS1M6
Windows 7 Enterprise 32 bit4.9014.9049.4 TS1M39.4 TS1M6
Microsoft Windows Server 2012 Std4.9014.9049.4 TS1M39.4 TS1M6
Microsoft Windows Server 2012 R2 Std4.9014.9049.4 TS1M39.4 TS1M6
Microsoft Windows Server 2012 R2 Datacenter4.9014.9049.4 TS1M39.4 TS1M6
Microsoft Windows Server 2012 Datacenter4.9014.9049.4 TS1M39.4 TS1M6
Microsoft Windows Server 2008 for x644.9019.4 TS1M3
Microsoft Windows Server 2008 R24.9019.4 TS1M3
Microsoft Windows Server 20084.9019.4 TS1M3
Microsoft Windows 104.9014.9049.4 TS1M39.4 TS1M6
Microsoft Windows 8.1 Pro x644.9014.9049.4 TS1M39.4 TS1M6
Microsoft Windows 8.1 Pro 32-bit4.9014.9049.4 TS1M39.4 TS1M6
Microsoft Windows 8.1 Enterprise x644.9014.9049.4 TS1M39.4 TS1M6
Microsoft Windows 8.1 Enterprise 32-bit4.9014.9049.4 TS1M39.4 TS1M6
Microsoft Windows 8 Pro x644.9014.9049.4 TS1M39.4 TS1M6
Microsoft Windows 8 Pro 32-bit4.9014.9049.4 TS1M39.4 TS1M6
Microsoft Windows 8 Enterprise x644.9014.9049.4 TS1M39.4 TS1M6
Microsoft Windows 8 Enterprise 32-bit4.9014.9049.4 TS1M39.4 TS1M6
Microsoft® Windows® for x644.9014.9049.4 TS1M39.4 TS1M6
Windows 7 Professional 32 bit4.9014.9049.4 TS1M39.4 TS1M6
Windows 7 Professional x644.9014.9049.4 TS1M39.4 TS1M6
Windows 7 Ultimate 32 bit4.9014.9049.4 TS1M39.4 TS1M6
Windows 7 Ultimate x644.9014.9049.4 TS1M39.4 TS1M6
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.